SingleStore can run that really fast but other concurrent readers can run at the same time and they won’t block. We use multi-version concurrency control to allow this. So there may not really be any problem to solve, it should just work.
If you really have a problem, you can use resource governor to run the update and put a hard CPU limit on the connection where you run the update.