UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3MGNCZ4Zi8x0AUyWmKYqje/RR7VK9qM+VWEuI7QmMS0=' 
WHERE 
  key_id = '727bc264ced1f3070843e0af8a69c0d45f9d44681ee12f7e96667e14165d0e71' 
  AND (
    token = '3MGNCZ4Zi8x0AUyWmKYqje/RR7VK9qM+VWEuI7QmMS0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00081