UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X71h8A1sUlLUYCRvPaulJ9eyDmEzGziWTwtm4YG/Odo=' 
WHERE 
  key_id = 'd38cec332c4aa5cc1fafab5bc366f31a52bbf4f7c5ea24bbceede191ace3b5be' 
  AND (
    token = 'X71h8A1sUlLUYCRvPaulJ9eyDmEzGziWTwtm4YG/Odo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023