UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'A8OcnzSG8FwTLX9hPRQcigNdOIheRwg9oJV9+jf5hgE=' 
WHERE 
  key_id = '70a11cf6e823fbf05cc754e9e83d1138b1b587c675f92488756d8a062d2d640e' 
  AND (
    token = 'A8OcnzSG8FwTLX9hPRQcigNdOIheRwg9oJV9+jf5hgE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028