UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6rv5PZAQ1QfJw7P0pBreP7eBpLMgCZTtw7rLoE9uo0='
WHERE
key_id = '0be683d4d38ed66a1af6fae867b3e6ef591aac6d3c3f1badd52873d59ad3a3ea'
AND (
token = 'p6rv5PZAQ1QfJw7P0pBreP7eBpLMgCZTtw7rLoE9uo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)