UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'riE0aXZU5A8j+8MP7NLJ6/6fRrheqrmg32TQQ6DPK+U=' 
WHERE 
  key_id = 'ec17cfe4347911471bf656c5663698307cff7d152e5046d5397eee5ed4872482' 
  AND (
    token = 'riE0aXZU5A8j+8MP7NLJ6/6fRrheqrmg32TQQ6DPK+U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037