UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kDz6Skc28yZQ3rRL4TOF7dsY3Mk03jW0VDYH0VrIZdQ=' 
WHERE 
  key_id = 'b816edcc03e4dcdea188aa27ea74d6b4bc6b2ec9c6084c56ec6853c25ad368af' 
  AND (
    token = 'kDz6Skc28yZQ3rRL4TOF7dsY3Mk03jW0VDYH0VrIZdQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037