UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'G50OgTnUaHPPJ5voqTA53GAB7al2p213q4iqSPqOG0A=' 
WHERE 
  key_id = '713d4e6ae58954a0282f55ce30bf77b2118a5f79fcb1618828b4d17e02c6c167' 
  AND (
    token = 'G50OgTnUaHPPJ5voqTA53GAB7al2p213q4iqSPqOG0A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033