There are instances in which you can open locked doors without a key. If you see the message "The lock looks fragile", try breaking down the door with attacks.

If you're having a hard time finding a certain key, and there are no enemies nearby who need your attention, you may want to try breaking down the door. Stronger weapons do the job faster.