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