UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3FaSKXv5QS4PccO4DQ1UgWdheFC86A37ICKZQbOJ1l0=' 
WHERE 
  key_id = 'bf3c2a7ce87b978ad0d459302f2b249288363c1b3c43ff9de6923457f36d1032' 
  AND (
    token = '3FaSKXv5QS4PccO4DQ1UgWdheFC86A37ICKZQbOJ1l0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043