SET variables in JDatabaseQuery

I'm trying to write this querry:

SET @rownumber = 0;
UPDATE #__hikers SET rank = (@rownumber:[email protected]+1)
ORDER BY score DESC;

like JDatabaseQuery, but still got an error. Please help