They may be able to re-set your pin number and have you make a new one. If not they will cancel the card but to me that is a waste. Generally they can just re-set the pin if it is from a bank they can scan it "ON location".
If it is not from your bank, they may have to just cancel it.