A card will appear as locked in Connect Manager after the card holder has failed to enter a valid PIN for 3 or more times when doing a balance enquiry.
For a card that shows as "locked" on Connect Manager there is no automatic unlock - the card has to be manually unlocked within Connect Manager (the only available action is the "Unlock" action button).