Does Sesame lock a database that is being accessed by a client?

No. Sesame will lock individual records on a first come first serve basis. If someone else arrives at that same record, it will be "read only" until the first person moves on.