UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7NxlKX8su/LipTHRrzektdNTAivlJxSIbnQFcoOuPE='
WHERE
key_id = '7e55597aa726b069111431e8fb6352c6e0ba172656470c4dced2177d7a65ef06'
AND (
token = 'x7NxlKX8su/LipTHRrzektdNTAivlJxSIbnQFcoOuPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)