UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWml6D6ShLCYVeY8cuzQg1BWv/9aO9BHUYlh88eeQMY='
WHERE
key_id = 'cdab5c2141d1b68067d30ea3f0ae5099086f19d92ce2d5037a3212150766f263'
AND (
token = 'ZWml6D6ShLCYVeY8cuzQg1BWv/9aO9BHUYlh88eeQMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)