If you stumble upon a locked door, and there no message mentioned that it need a key to unlock, then it will require your lock pick skill to unlock it. Lock pick skill is an important skill.