I asked about the doors while we were on the ground, just because I was curious. The cabin crew told me they would unlock them when we reached cruising altitude.
An hour in, nothing had happened, so I fiddled around until I managed to unlock it myself.
I must have been the only person to use my door in that flight, as they didn't lock it again before landing, so the door slammed forward upon touchdown.