Well, I had the same issue just this week!
The car was closed properly. We could not open the car with either of the two fobs. As
@jules_2998 used the mechanical key to open the door. The door was now opened / unlocked, but we still could not open the boot lid. I had to power up the car for that. We drove a bit with it, a planned errand, when we got back to the parked car, the same behavior repeated. It lasted for two days, then it went back to "normal" behavior.
I am hearing the 12 Volt battery pointing loud and clear. If the 12 Volt battery has an issue, I would expect the 12 Volt battery warning light to go on. I don't remember seeing it on. But I must admit I was not specifically looking for it either. I would like to believe if it was on I would have seen it.
One thing I do remember was out of the ordinary is the HV battery SoC was below 20% for a longer time. It has been rainy and overcast for most of that week and there was no sun to charge the car. Now, I'm not suggesting that has definitely something to do with it, but I do make a list of things out of the ordinary as a first shot at troubleshooting.
Another thing I noticed is the seat heating control circuits possibly leaking power. Even though heating was turned off, the seat seemed to be warming up slightly. My wife says it is my body heat, but I'm not convinced. That may drain the 12 volt battery too.
Lastly - I hope that is not it - we live within 100m of a park / nature reserve and our neighbors already had car cables eaten by Stone Martens. I have not checked yet, that may be another thing to look for.
If I find anything, I will report it here. Since the problem is not manifesting itself now, it is going to be difficult to do any troubleshooting as long as it does not. I've got extensive experience finding the causes of issues, I was also good at it in my professional career. Causes of issues others did not find I often found out about and with a pretty high hit rate. But I'm not guaranteed to, there have been problems I did not find the cause for. Often because of lack of knowledge or understanding on my part, learning never stops.