I use one of the many pouches that can found lying around to store all the keys I find. Even if the key is in the pouch it will open the door and remain in the pouch afterwards unless you use a different party member to open the door. Aside from initially putting the key into the pouch no other management is required.