UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tCqmV+htsYN98nlOrhjW/uyCsbDYxFOubgJ8VGVDXhI='
WHERE
key_id = '26aef891d0859a370499c1361d216fb23bd5f18afef1cefdb99555ff07ea1fc5'
AND (
token = 'tCqmV+htsYN98nlOrhjW/uyCsbDYxFOubgJ8VGVDXhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)