weird, I did all the night visits with no problem, the door only became locked again after they finished. I know someone managed to take this to 100% so I suspect it'll open again when other story points trigger. Maybe spend some more time searching for people talking to each other, or NPCs standing where they aren't normally, to find more questssince almost from the begin