UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cIMUXEcCTKRxcc+mtd1r237b7Zz0o2rgCUKg4xWwwAw='
WHERE
key_id = '97388d4ac791c46fb3a802c7f8538a216aaa0b06149f12f8d697c32a9bc057a0'
AND (
token = 'cIMUXEcCTKRxcc+mtd1r237b7Zz0o2rgCUKg4xWwwAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)