UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ygHZ03tX0al3mquMbj3VSO3+f9jX+edpUYyKX1upDHM='
WHERE
key_id = '49ed91c12030e502626effc3467fe6240c8640edb784094d88781b63be8426b2'
AND (
token = 'ygHZ03tX0al3mquMbj3VSO3+f9jX+edpUYyKX1upDHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)