UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pnNpsw3ESysg81SPkpC185hYgnqZ0qQ2qj5B3mdEVaM=' 
WHERE 
  key_id = '7cb2d54f758a89887581c122d6606b5ef796fa30f4cd85d329b963c4c9cfa5ba' 
  AND (
    token = 'pnNpsw3ESysg81SPkpC185hYgnqZ0qQ2qj5B3mdEVaM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031