You need a lockpick and points in the Lockpick ability to pick non-magical locks. There is still a Lockpick spell book in the game currently, but it will be removed.