UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VgS/0laH/SB1yjwBw5ICpP/PEOcOYAF8kJHhyPMUMbM='
WHERE
key_id = '8dafe11d379423c88bb8ae9ef62c08baa1b50249a9e3ff471921b8381ae06acb'
AND (
token = 'VgS/0laH/SB1yjwBw5ICpP/PEOcOYAF8kJHhyPMUMbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)