select
        i.identity_public_id
        , s.created_at
        , s.expires_at
        , s.revoked_at
from auth.session  s
join auth.identity i using (identity_id)
where secret_hash = $1;