I can only base my knowledge of picking locks on watching the LockPickingLawyer. :P
So, I looked at this video, mostly because the key looks like what you’d find in a fantasy setting, and it’s an older style of lock than the modern pin tumblers. He starts at 1:15, and finishes at 2:06, for a time of 51 seconds. Not too far off! and while a Pathfinder character will be pretty superheroic, the man in the video (for those who don’t know) is notoriously fast at picking locks, and has even competed in timed competitions—and he’s not in grave danger, like a player character likely would be. :P he also, interestingly enough, gets stuck, figure out what the problem was, and start over, which maps perfectly onto requiring multiple successes to fully open.
As for lock picks breaking, I don’t know. Bean counting aside, I don’t know how big of a deal it would be. I’ve heard LPL talk about breaking picks, but it’s fairly rare, unlike what you see in most RPGs that incorporate it as an element. But he’s also living in the modern day, where materials can be better and more consistent, and manufactured at scale. the people making lock picks, especially ones a thief an honorable rouge can get their hands on, might be making small batches by hand with whatever material they can get their hands on.
So I think it’s actually firmly realistic enough for suspension of disbelief.
Yeah, written in a little booklet and everything. You don’t have to pass it down as an oral tradition from generation to generation!