I wanted to check the expiration date of certificates used for SQL database mirroring.
Here is how you do it.
Just open SQL Management studio and make a new query on the master DB:
select * from sys.certificates
In the results you can check the expiration date and time in the column expiry_date.
Remember to renew the certificates in time