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