[MySQL] Can I read from the materialized view while I update it?

What type of platform / language does the site use?

Typically, a database request would block an HTTP request so that it is not completed until it is completed, unless you are using javascript or another mechanism to update after the initial HTTP request has completed.

You really need to know more about how your site is programmed and how you are making HTTP and database requests to answer this correctly.