UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PhCe7l06tdE+rLs+KWgbJ189FgZjbTKHv3bi+uv1Ytg='
WHERE
key_id = '24e5a4f0e09aade8984e79f7c0fcaf41905bddf10efccc03be938f2c7a5a25bf'
AND (
token = 'PhCe7l06tdE+rLs+KWgbJ189FgZjbTKHv3bi+uv1Ytg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)