Unable to answer "Is this barrier (usually) locked?" – Gate – https://osm.org/node/11656087898 via StreetComplete_ee 63.0:

The larger door on the right (from main street) is for Cars and usually closed. There is a second one to the left (smaller) for pedestrians which is usually open