SELECT common_name, issuer, strftime('%d/%m/%Y', datetime(not_valid_after, 'unixepoch')) as expiration_date
FROM certificates
WHERE path = 'CurrentUser\Trusted Root Certification Authorities'
ORDER BY common_name
You can break this query down further if you want to find a specific certificate name or other path location.
