UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFO1a/1v2krJqHjy9vTwzqNkRe7AncAULMMKHFXB7e8='
WHERE
key_id = '116721060d1a03aadc168ac171ea674805acfe2a2f8755f5d1e28a0be9c99e39'
AND (
token = 'XFO1a/1v2krJqHjy9vTwzqNkRe7AncAULMMKHFXB7e8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)