No, unless you fail in which case you need another lockpick. If you fail often enough and run out of lockpicks, the icon will be greyed out and you cannot proceed. As Taril explained it just tells you that you need one to open the lock.
I feel it is more obvious with the trap disarming kits as you run out of those more often than you run out of lockpicks.
