You can easily find that using

SELECT LOGINPROPERTY(‘TestUser’, ‘IsLocked’)

You can unlock the login using

ALTER LOGIN [XYZ] WITH PASSWORD = ‘****’ UNLOCK ;

GO