UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '120JDOkXbE9nf9T1ruIoHF/SHy9f7PKYeerbIYsnqo8='
WHERE
key_id = '0a006703a35983486e31932efd6e94ae4357dd6905591b536c4e77b3c63c5212'
AND (
token = '120JDOkXbE9nf9T1ruIoHF/SHy9f7PKYeerbIYsnqo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)