Try:
=MINIFS($B$1:$B$6;$A$1:$A$6;"Expiring soon";$C$1:$C$6;"Valid")
Column B: Includes values. Column A: Includes expire check. Column C: Includes valid check.