I have the exact same issue, my nearside rear door will lock and unlock most of the time, then will be temperamental. Lots of locking, unlocking, locking, unlocking, ear to the door to see if I can hear it unlocking and then it eventually opens
It's worse when it's cold for some reason
Mines...