UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EjIlNAHiD9ZbLe5w9xrNJkS4sAmhad/H7Avh/HQ4tgo=' 
WHERE 
  key_id = 'da14cf6fe4a2929319e3fe58c33431395f634189e42370bd079acbc51b405e2e' 
  AND (
    token = 'EjIlNAHiD9ZbLe5w9xrNJkS4sAmhad/H7Avh/HQ4tgo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022