For a rear hatch lock that will not unlock and will not unlatch, I figured out the problem on my 2006. The return spring on the latch got weak and would not return the latch mechanism to resting position when the handle cable is relaxed. The mechanism not returning to the proper testing position blocks the lock mechanism from going to the unlocked position. I fixed this by adding a helper spring to the latch mechanism as shown below. This helps the latch mechanism always return to resting position so the lock mechanism can unlock.
Getting to the latch mechanism with the hatch locked is a bit tricky, so I will tell how I did it. Access the hatch from inside. Remove the two handle bolts, and the two small bolts behind the first aid kit. Then hook the panel through one of the handle bolt holes pulling away enough to get your fingers behind the panel and gently pull it away from the hatch, beginning at the bottom. It has a number of clip fasteners scattered across the panel, but no other screws. Once the panel is removed, remove the insulating sheet from the hatch. Then reach inside the opening on the driver’s side and find the cable that comes from the handle and push the mechanism to the resting position so the relaxed cable gets taught. (Mine actually had slack in it due to lack of spring tension.). Once you return the latch to the proper resting position, you can fully unlock the latch with the key-and open the hatch normally. Then remove the three black mounting bolts, the nut, and the lock mechanism rod. Unplug the two wire connectors, and you can remove the latch assembly. I left the cable connected when I did the modification. Add a helper spring as shown, re-assemble everything in reverse order, and you are back in business. Hopefully this is helpful because a latch assembly was over $200 from the stealer.