[Ibapah]

UPDATE <prefix>user
SET password = MD5(CONCAT(MD5('new-password'), salt))
WHERE userid = X

...with 'X' being your userid number and <prefix> being your table prefix.