# get the row for each user based on each userid's max individual expires

SELECT
    userid,
    expires,
    make,
    model

FROM
    tbl1 t1

JOIN (
    SELECT
        userid,
        MAX(expires) AS max_exp

    FROM
        tbl1
    
    GROUP BY
        userid
) t2 ON (
    t2.userid = t1.userid AND
    t2.max_exp = t1.expires
)