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

SELECT
    userid,
    expires,
    make,
    model

FROM (
    SELECT
        userid,
        expires,
        make,
        model

    FROM
        tbl1

    ORDER BY
        userid,
        expires DESC
) t1

GROUP BY
    userid