If you want to avoid the key issue, the variant with a double-bit lock is of little help, because this key provides easy access and would therefore have to be secured in a safe with the same or higher level of resistance (see Higher Administrative Court of North Rhine-Westphalia Münster, 20 A 2384/20).
The variant with the mechanical combination lock makes more sense, but there are two serious things to consider:
The “DUET” lock from NL-Locks, for example, offers a fully integrated solution. The lock also has approval according to EN1300, Class B. However, this lock is not included in almost any safe manufacturer's lock list, as the lock has a much higher lock housing due to the double technology than all other locks on the market. For this to happen, numerous changes would have to be made to the certified safes. In view of the expected low quantities, there is currently no known manufacturer that will bear this immense cost just to be able to theoretically install this type of lock. Therefore, this lock will not establish itself on the market in the short or medium term.
Individual manufacturers take a different approach and simply mount an electronic lock on a push carriage. A normal mechanical combination lock is then placed behind it, which is screwed to the push carriage via a linkage and pulls it out of its locking position when the mechanical combination lock and electronic lock are opened. If the screw connections are not tight or the carriage is jammed, e.g. due to abrasion of the locking mechanism or poor assembly (both of which are not as rare as one might think), serious malfunctions often occur in the rarest of cases where this function is needed.
We do not see a general need for a redundant system, however designed, for normal everyday use. The risk that a modern electronic lock fails and can no longer be opened without damage by a good safe technician tends to be zero. The risk that you will forget your code at some point is significantly higher.
TIP: A modern electronic lock usually comes in the basic version with software that allows you to create a second code. Always use this option and always use digits in the second code that are not in the first code. This means that even if the number key is damaged, you can always open the safe with the second code.
EVEN BETTER TIP: If your partner doesn't have a firearms permit, you are of course not allowed to reveal your code at first. But what happens if you die unexpectedly, for example? Nobody knows your code. Our idea: do you have a will? We recommend leaving the MAIN CODE in a sealed envelope as an attachment to your will. The important technical term for this is “in official custody”. You are the only person who always has access to this envelope during your lifetime, so you can gain access in the event of a forgotten code, and since this is the main code, you can use it to reset and overwrite the forgotten code! Due to the fact that it is in official custody, you can also mention to a potential heir or estate administrator where a code for the safe is located. But that person won't be able to get to it during your lifetime, so: everything is well taken care of and everything is done right.
PANIC ROOM: If, for example, you would like to be able to open and lock an armory door from the side of the room, this only works with an electronic combination lock, since only this type of lock does not create a mechanical connection between the lock housing and the opening unit (handle, number wheel), but rather two input units work here (keyboards), which are connected via a BUS distributor to the electronic unit located in the lock housing, and enable operation from both the room and the aisle side. This is safer and more efficient than any mechanical locking device that is prone to failure.