UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fnG9Pmb0mnbah+p8BLrkCJRslrVIBuDO1ZIx+RY4xgU='
WHERE
key_id = 'e0416ece17305cf8225a670b7fd35980c8b786c9c6a3c0ae456e4dac55dc3794'
AND (
token = 'fnG9Pmb0mnbah+p8BLrkCJRslrVIBuDO1ZIx+RY4xgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)