You can do it in a single command:

CREATE PROCEDURE dbo.GetExpirationValue

@UserEmail VARCHAR(50)

AS

SELECT a.email, a.membershipexpiry,

IsExpired = CASE WHEN a.membershipexpiry < GETDATE() THEN 1 ELSE 0 END

FROM dbo.tbl_a a

WHERE a.email = @UserEmail

GO