Does it lock if the DB is opened in write mode, or only when a write query is issued?

If the latter, then it’ll only contend on simultaneous writes, which mutex anyway.