In the 777 at least, the door unlocks if the aircraft depressurises.
Wow. That certainly throws some water on the whole "intentional depressurization to knock out the passengers" theory. Although - is that just the "standard" door lock? Can someone on the flight deck still override that?