UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r86dWj9eEeh/znLrttFVGlRXwM0W/r4snpP3pDZe/JI='
WHERE
key_id = 'd8654c6b71310152278cee27fab1a8a0cbc8a8eb772e3e6cdc3c0a744ce3bba1'
AND (
token = 'r86dWj9eEeh/znLrttFVGlRXwM0W/r4snpP3pDZe/JI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)