UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8tBKJCj08etE2Upj0H7eAwR4NZBFIBHHxqZLjf4exA='
WHERE
key_id = '1cb11d67d371147ed6f9de8511a5f1cb476041c0efcf96a8d80b6548ce32c5fe'
AND (
token = 'X8tBKJCj08etE2Upj0H7eAwR4NZBFIBHHxqZLjf4exA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)