That's bizarre that the mechanical key turns and doesn't unlock the door. It is possible something failed behind the door panel.
OP may need to call a locksmith or roadside assistance. Many years ago, I accidentally locked the keys inside a rental car. Roadside assistance came and used and inflatable balloon-type device between the edge of the door and the frame of the car. It temporarily bends the door enough (which did spring back) for him to get another tool inside the car to push on the interior door lock or door lock switch.