The two main places where you'll need lockpick are specific chests and locked doors around the map. You'll only have the option to open most chests with lockpicks, but for most locked doors ...

There are all manner of chests and locked doors to be found as you explore ... so you will need lockpicks. You might even need them a lot earlier than you think, depending on where your adventures ...