UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xl7NG9xfr3fZby0fILMHsvj7sHI1h2QbomRuQ3UwMck='
WHERE
key_id = '4714ab6af9c0fbfe7edefd77e6b095b82e355ab0d2ada1aae90fb4942cc3a3d2'
AND (
token = 'Xl7NG9xfr3fZby0fILMHsvj7sHI1h2QbomRuQ3UwMck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)