UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tnagDx0jLTc4QxocPaUGreXlpyskjZC/HI9CbHe2uH4='
WHERE
key_id = 'f41b6d923b137fd3fc40fdda31e170a1d4021f39d588c7b62cdfbf7a27ac9a78'
AND (
token = 'tnagDx0jLTc4QxocPaUGreXlpyskjZC/HI9CbHe2uH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)