UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHMH6YLpRoZhSFTKazDhiq3WT5wsj1g5cqL0DA1O24s='
WHERE
key_id = 'd61cc33ebf7dcd77ca1df26567a33005b96f58a3f011ff0aef924df75de30fe7'
AND (
token = 'tHMH6YLpRoZhSFTKazDhiq3WT5wsj1g5cqL0DA1O24s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)