UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1qG4i/pKKVHNPgpY68GyxHkNPR0/nlsGQSFq72etahk='
WHERE
key_id = 'd6b2937f0e82c4676c28fae3acb85774695ceb4a16d0945c482a485c527cde56'
AND (
token = '1qG4i/pKKVHNPgpY68GyxHkNPR0/nlsGQSFq72etahk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)