UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7VAzpvXGOFYeicukJlE0htS3BXLlZ0OWpA06M9RwNE0='
WHERE
key_id = 'ae1e2634174f930be42ecb087b61b23cef7de1ce5676d4a0fa84b4cb88f4a952'
AND (
token = '7VAzpvXGOFYeicukJlE0htS3BXLlZ0OWpA06M9RwNE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)