UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0xn3lipKrWGDXsYIg9Lel6XiuL/iLeorxpmtMNZ/QgM=' 
WHERE 
  key_id = '892bae89784f41c4149ac32daa194f1fc5a90ba85e7c76bc3decfc0317d7cf0e' 
  AND (
    token = '0xn3lipKrWGDXsYIg9Lel6XiuL/iLeorxpmtMNZ/QgM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027