Test for order by `col = val`

order_by_test.sql

BEGIN;
CREATE TABLE order_by_test (
    id SERIAL PRIMARY KEY,
    token INTEGER NOT NULL
);

INSERT INTO order_by_test(token)
SELECT id
FROM generate_series(1,10) AS id;

SELECT * 
FROM order_by_test 
ORDER BY token = 10 DESC, token = 9 DESC;

ROLLBACK;