UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8SO98BiLh7gr2KIU0PB11H328ZpI+yu8wMDko0I8arE=' 
WHERE 
  key_id = 'd4ef5ff4dac95d137981fc14e2f2bedd46be6c85c8593491baaa76ce91e26d83' 
  AND (
    token = '8SO98BiLh7gr2KIU0PB11H328ZpI+yu8wMDko0I8arE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027