You narrate what happens because the PC asked to do something. And for lock picking that is exactly what the DMG tells you to do on page 28 "For example, failing a Dexterity check to pick a lock on a treasure chest doesn't mean the character can't try again, but each attempt might take a minute...