UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBo8HFo0M8+ukHhIorvr9j+5MjNCgSWe8+GlepI2wWM='
WHERE
key_id = 'd9722507a245d5a2c0f848c890731dae17d6251833bfc678c145d048521fc5bb'
AND (
token = 'ZBo8HFo0M8+ukHhIorvr9j+5MjNCgSWe8+GlepI2wWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)