UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sT7Qe11BgGYVTJ1dP3LYGr0b9n4ENhAnlIZCNPFFq54='
WHERE
key_id = '27b3baad5dba134a6d209330d3efea12b3a5a2ac34d570e16c10ad7e12dee7d0'
AND (
token = 'sT7Qe11BgGYVTJ1dP3LYGr0b9n4ENhAnlIZCNPFFq54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)