UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCBZPg4/GSTfybPsfr/nlCwTi1Yi1AhLLpM6vZT5ymU='
WHERE
key_id = '9165a6b14be9ab8c6dc1b15824654a5e6c97d0be685fe888d9782594801543e3'
AND (
token = 'ZCBZPg4/GSTfybPsfr/nlCwTi1Yi1AhLLpM6vZT5ymU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)