UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f67FowfECkbfV0cJMqi8vkXMSO7r4rmINi2w2qApnxU='
WHERE
key_id = '1123f8d3bb358929b980d707a4aba96a4b1de7f0c52777777efc5c629e6dad9a'
AND (
token = 'f67FowfECkbfV0cJMqi8vkXMSO7r4rmINi2w2qApnxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)