Sounds like the lock module has failed. You can try slapping the door while pressing the lock/unlock buttons. But they get to the point where even that doesn’t work. It’s a common
problem on all the MK4 Golf based cars and it’s worth replacing them as soon as they start acting up.
The rear door card is easy enough to get off even with the door closed, since all the screws are accessible. But on the minus side removing the window clips is harder than the front ones. Most people say to smash the plastic section of the lock until it opens. But apparently access to the rear ones in the
MK1 Leon is a right PITA.
My driver’s door wouldn’t open so I researched this
problem a couple of weeks ago, but thankfully it was an almost flat battery (little use over lockdown). There are guides online & YouTube and I used them to replace my front passenger lock last month. But I could still open the door at the time.
There are few videos showing people opening stuck locks by drilling access holes and manually moving the lock levers. Given the lack of access in the rear doors, I’d be tempted to do that. Another suggestion I saw was melting the plastic section of the lock with a soldering iron.
Whichever way you do it, it doesn’t look an easy job with the door struck shut – good luck.