UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xK5KSJVtrjZb8oYv6a0z0jsKYp8xlK7AkRay0VuD++Y='
WHERE
key_id = '31f1705bbba19ed5ef9a357442427c3442ae8efb443ae39e272489fadcde8540'
AND (
token = 'xK5KSJVtrjZb8oYv6a0z0jsKYp8xlK7AkRay0VuD++Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)