UPDATE 
  q_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TYSVEzyyyAWE4U9pE+z9HSbcS4WbaZA2Qr62RPfqxrI=' 
WHERE 
  key_id = '3e8795a323c426d38398e5e0a1817a076ca2f6ec3f470f5ebf4328e09a1a55d9' 
  AND (
    token = 'TYSVEzyyyAWE4U9pE+z9HSbcS4WbaZA2Qr62RPfqxrI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028